package com.yuwenchao.superafflatus.mapper;

import com.yuwenchao.superafflatus.pojo.entity.SuperSalary;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yuwenchao.superafflatus.pojo.vo.SuperSalaryVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author ChaooGG
 * @since 2021-05-31
 */
@Repository
public interface SuperSalaryMapper extends BaseMapper<SuperSalary> {

    //查询统计薪资详情
    SuperSalaryVo getSalaryCount(String company);

    //展示最近薪资详情
    List<SuperSalary> getSalaryInfo(@Param("start") String start,
                                    @Param("end")String end,
                                    @Param("company")String company,
                                    @Param("total")Integer total);

    SuperSalaryVo getSalaryCountByYear(@Param("start")String start, @Param("end")String end);

    SuperSalaryVo getSalaryCountBySumYear();

    SuperSalaryVo getSalaryByYear(String year);
}
